UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcdxQ8nKg+i3T9VmM7+lnVpZk/8DCYy+81Nl3teAY9o='
WHERE
key_id = 'ab4f25b659d28ccfe183eb02b4d703cd05f83fe5abbefea484ac58ad9103a269'
AND (
token = 'ZcdxQ8nKg+i3T9VmM7+lnVpZk/8DCYy+81Nl3teAY9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)