UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aMCp2B5QPd0Nx6SUjqpkCeYpcVu00WmISUpiLxLoCrU='
WHERE
key_id = '573ca8ea22e4a6b8b939668143507338a8dc14571328938f1659f5ce80098811'
AND (
token = 'aMCp2B5QPd0Nx6SUjqpkCeYpcVu00WmISUpiLxLoCrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)