UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMyHyeAQE2xhpRC4CljIrsDeYAiF/IztwRb/472+ZUU='
WHERE
key_id = 'a4204b5b5173ecb93c6a4539df07d142d445cbc63be7bc9463a7702d95ca8000'
AND (
token = 'EMyHyeAQE2xhpRC4CljIrsDeYAiF/IztwRb/472+ZUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)