UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpdh3OjrVlOxpVuBfeWeWtjdZzwaNMp32EuWCpDrKe0='
WHERE
key_id = '83272c7010089a117291f73516ed895179c37c96be4327b83cb03887fbd27785'
AND (
token = 'bpdh3OjrVlOxpVuBfeWeWtjdZzwaNMp32EuWCpDrKe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)