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