UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwQva2zEpBqkrqdWvWcOwJGPZCkfMBpA5Wq4pSK1coc='
WHERE
key_id = '1fadaecd12a67fe8308c4ae13e9e7864e083b3733936581da3b56991717d5894'
AND (
token = 'XwQva2zEpBqkrqdWvWcOwJGPZCkfMBpA5Wq4pSK1coc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)