UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7t34SYQaocp3ja999jT8W1hdKwwNSi6CaeyYbUOLZY='
WHERE
key_id = '3fa5c83b9d03c2d7b72878d48da69a03c988301b80a7843935a08857c8e8a1a2'
AND (
token = 'G7t34SYQaocp3ja999jT8W1hdKwwNSi6CaeyYbUOLZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)