UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXE+IZJT51O9MYRsxDjFfcvF08dswCg5XO01PmxWkj4='
WHERE
key_id = '4039e2e3e6d4bf543b2026919ab143f74251a418fae3b7add2c0c3d0b358c6bc'
AND (
token = 'gXE+IZJT51O9MYRsxDjFfcvF08dswCg5XO01PmxWkj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)