UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A3E9Rb/LZkwSBUlHwPtJ5qX6HSrV+9uLmH9gHL3G7UU='
WHERE
key_id = 'dd6cb53c9aaa1b25ddec2f19c7aa091b1d556d47a4856632ccefe6ccab773dd4'
AND (
token = 'A3E9Rb/LZkwSBUlHwPtJ5qX6HSrV+9uLmH9gHL3G7UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)