UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dr0ICifDMWdyhrD6orY4RnS3IGgJM5r8hqOz3OdBy04='
WHERE
key_id = 'a2c2bddefb4a821c8c3e5bf2c6fd2379e6e1b8fc73a34d430a8642c883ba24a8'
AND (
token = 'dr0ICifDMWdyhrD6orY4RnS3IGgJM5r8hqOz3OdBy04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)