UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYCr+UwMNYRnZSjILL9Dsx2cEIXwEM6h7HPbQg1wZos='
WHERE
key_id = '867a77779717e3d0e2d6860eec7d9e780d18eae0dfe7cfede8827ee37acab038'
AND (
token = 'zYCr+UwMNYRnZSjILL9Dsx2cEIXwEM6h7HPbQg1wZos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)