UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RCpcoUbvFuRmn/qC5w3G+vcQ1GJYEEkseczXLGAkX4g='
WHERE
key_id = '00b3513acb4d347d75b0d7016e9ae812893bc0ad161cbc1800a1be976a465c1d'
AND (
token = 'RCpcoUbvFuRmn/qC5w3G+vcQ1GJYEEkseczXLGAkX4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)