UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tct9UGmuF/6PiDbi7kceS07qUZK+tkU2y1I1NUglJ84='
WHERE
key_id = '3a7f683eb686a81120b43b6d29d476da080951a8aa48e1cbfd94fb40b5d0e616'
AND (
token = 'Tct9UGmuF/6PiDbi7kceS07qUZK+tkU2y1I1NUglJ84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)