UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAtgIg18AB524aQ1A8bRmGAHt2pwBzC8TKhci8xHv18='
WHERE
key_id = '9367ade1cd14bcab2dacddbd1d56a670a4a8941f72740973574781452fada199'
AND (
token = 'kAtgIg18AB524aQ1A8bRmGAHt2pwBzC8TKhci8xHv18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)