UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nkKJjTrAEI9H6cZWakm993VTb3h84p73I80H56Lmbk='
WHERE
key_id = 'ab31be417847ea84b2578fcf0e8a4a03013a7bb368f4775e362dc4ea937a6d89'
AND (
token = '9nkKJjTrAEI9H6cZWakm993VTb3h84p73I80H56Lmbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)