UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNsbp9f8Vu5ihTUPLPlkP555+OolJgAKvOkSZeZ4wJ4='
WHERE
key_id = '3e9c95c4bc210f2ed6cc0022af81cc69c32f7bc58c81c5d62168ef962bb1fdfd'
AND (
token = 'xNsbp9f8Vu5ihTUPLPlkP555+OolJgAKvOkSZeZ4wJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)