UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0jrwkmvrHHG0HWAorwERnQl2TAYDidok12zSkazlWo='
WHERE
key_id = 'be6b837cca25191d7115b217eaeb8494fa484da33223b25796d4aeb8c3f2b27b'
AND (
token = 'm0jrwkmvrHHG0HWAorwERnQl2TAYDidok12zSkazlWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)