UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+E7gY74DBYmOW8JRvh1FfDzwq+xh8ZRlWkZiN5FWn0s='
WHERE
key_id = 'f9143314868b55db74082f732f6440a8b2237326775d9bb630a4bc99bd8a9171'
AND (
token = '+E7gY74DBYmOW8JRvh1FfDzwq+xh8ZRlWkZiN5FWn0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)