UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPkQA0ccEhzjMDDuqD+B31YQ9aH/q5LRl3wh0L9/FYw='
WHERE
key_id = '8b48b89493e2330bf43db6ed31b704965ddec4d9091092c5563262168ea02235'
AND (
token = 'tPkQA0ccEhzjMDDuqD+B31YQ9aH/q5LRl3wh0L9/FYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)