UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQ2FHUeuRA+GUjqcFlzx3P20WHsJ+kOo9+1Z4oXmzjI='
WHERE
key_id = '30027dbdb711474865a6673a38ac9893390740a2e7cc0807671cb5d23d008e4a'
AND (
token = 'dQ2FHUeuRA+GUjqcFlzx3P20WHsJ+kOo9+1Z4oXmzjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)