UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Ae4nClwxScyD6uaPpcoIxwVDPzm7Z6gW0glHnmCZkM='
WHERE
key_id = 'e3303283f2252750c66800e56fe6e9ac84b2a0c6b2f9f7b0689188b952419d7a'
AND (
token = '1Ae4nClwxScyD6uaPpcoIxwVDPzm7Z6gW0glHnmCZkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)