UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IZ/HkkGUvcLtsFCKr+znX4xdwQCh1GBiSOi5FrF1BT0='
WHERE
key_id = '38ac906fbd8eaaed546dadec593db5c08befa18a8a20150de25c64067f49463f'
AND (
token = 'IZ/HkkGUvcLtsFCKr+znX4xdwQCh1GBiSOi5FrF1BT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)