UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'biQBotpZK1djOUM+SeDu5C4hQ04ZXOPgkcsN/Eebncc='
WHERE
key_id = '46637f70ba872c6cdbb4957c15372e8fa3a73dd03816153962bf11c04f07a407'
AND (
token = 'biQBotpZK1djOUM+SeDu5C4hQ04ZXOPgkcsN/Eebncc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)