UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPXn/Hlv66PT6TTYKDz1paEaGiogbPhMcXpXqz5GNBU='
WHERE
key_id = 'ad079c729007512ce9a0353f76f11aabe41839d998939376b0653b9033df7913'
AND (
token = 'pPXn/Hlv66PT6TTYKDz1paEaGiogbPhMcXpXqz5GNBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)