UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rTpB2caVgZM42wgDMXAPvKb2j5n1seci1cooDyY9Tkg='
WHERE
key_id = '9ad6c8e258c8cd5df703e3a365dd95d4530e22e4f1e7b369295f2e4fb758f1ff'
AND (
token = 'rTpB2caVgZM42wgDMXAPvKb2j5n1seci1cooDyY9Tkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)