UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KxZc459zujX7HzMRXYZs6uZVsy6OPn4H9yrhEz4r2C0='
WHERE
key_id = '72056f6f4464c128b3d662ed4425b1e0e0235324f82d86abe51cd08a01049899'
AND (
token = 'KxZc459zujX7HzMRXYZs6uZVsy6OPn4H9yrhEz4r2C0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)