UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dm1tfysXsD7CJHSn7284kAsmvp1IcwONRQZOIuXoCM8='
WHERE
key_id = '99b9a1c5f58d315f098b2ca80ee586b4aef947e1d20fefc2fd3dd7011b30a611'
AND (
token = 'Dm1tfysXsD7CJHSn7284kAsmvp1IcwONRQZOIuXoCM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)