UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MfN+2jOmTrH1XJU0+BoJlfhY43/N8F3ooVAzy+i6vM='
WHERE
key_id = '19ea4d0df35c8c4df3c47a1256b188a0d9625b662f6f3336865d881ba05d3700'
AND (
token = '0MfN+2jOmTrH1XJU0+BoJlfhY43/N8F3ooVAzy+i6vM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)