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