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