UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6bd4XRZ07xU9I/g2L1gsBII8OOczr6puKmliGM49s14='
WHERE
key_id = '3b2d07c9f2d0e35a700919dee9cb5f466e168319928a54d3e78b757a16a21d40'
AND (
token = '6bd4XRZ07xU9I/g2L1gsBII8OOczr6puKmliGM49s14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)