UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5lnWCy4zIpEdLJBB4sBsAtcIcKo6+q6lWsW+7wyq3GM='
WHERE
key_id = 'e6031a162b3b02b72c48eb48b8bb098c257e36a6a2c58da7e4a183281f632f09'
AND (
token = '5lnWCy4zIpEdLJBB4sBsAtcIcKo6+q6lWsW+7wyq3GM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)