UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzf11nNUTMINb3VTC6Wy3mxrpiQ2jPdx8CfmhTxciSE='
WHERE
key_id = '23f9e77bb4b15aeca75ca8faa91933455255e0f526f30eaefb6a4973b32a7b71'
AND (
token = 'kzf11nNUTMINb3VTC6Wy3mxrpiQ2jPdx8CfmhTxciSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)