UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3xRMerTNgwGZ2TL3YNs19PPCE8PmVEenUKFrCdoBaE0='
WHERE
key_id = '5a5341f5fcb7d57f99864357ecc816563b83d035e17e0c3f9336207a31418a48'
AND (
token = '3xRMerTNgwGZ2TL3YNs19PPCE8PmVEenUKFrCdoBaE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)