UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ekBiYuerq5oinUavFmNTarVqeUU4tqE3denimPadoAk='
WHERE
key_id = '581b511fc6f1ee67a5f98a7baca6404a92d2d910ef8d25bfa3378f872d53fbec'
AND (
token = 'ekBiYuerq5oinUavFmNTarVqeUU4tqE3denimPadoAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)