UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgV6BN/ElE+wD9gwIb5mNBTweTZSYxn20WV0KDCeN58='
WHERE
key_id = 'edaef48166c8127cdf9b8d7f7ba8754dc46a6a671317b279ee8eeb17cc044d81'
AND (
token = 'qgV6BN/ElE+wD9gwIb5mNBTweTZSYxn20WV0KDCeN58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)