UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MD8qqqSrQ5vGYNHialP4w6m1Sdh8tPBxNU4K7npU970='
WHERE
key_id = 'fa8f742207538e45129c2b6eac643b1ad0f4bea200067761dacdff0cf1a61420'
AND (
token = 'MD8qqqSrQ5vGYNHialP4w6m1Sdh8tPBxNU4K7npU970='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)