UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAFNA9/0XZuLDWBgc9WZ1T0jEfV2kQo4WiYoLHOeOYY='
WHERE
key_id = '0ea1b44c5d080715ba41e7b6bf08f157ab1c8a413ca46934afbf6103091ce7c0'
AND (
token = 'kAFNA9/0XZuLDWBgc9WZ1T0jEfV2kQo4WiYoLHOeOYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)