UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qf912mzj0vmZeFUY6C2UHm3Z86Bv5OkIvGBuUusM89s='
WHERE
key_id = '1e4d912996a64a8dd87a8a98341b3b10386c507a9d29b3b1c3493a84a735fa00'
AND (
token = 'Qf912mzj0vmZeFUY6C2UHm3Z86Bv5OkIvGBuUusM89s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)