UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhg6LiZDEo4AZMnmJP0QBDbtMwSXV30HfFCVVod/ZGY='
WHERE
key_id = 'd04a8bdd4b8ca847b358c8b53469d58a451006a790b02ac2e90b5eaa4e9bca94'
AND (
token = 'qhg6LiZDEo4AZMnmJP0QBDbtMwSXV30HfFCVVod/ZGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)