UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3phcVMTuawDIzV8V++EPKyIbDu6bc1Pk+KWS7KpjtQM='
WHERE
key_id = '91673e2be15612cecddba79ce74070829f632bc0c4c2db7d87bac550c0dd2d24'
AND (
token = '3phcVMTuawDIzV8V++EPKyIbDu6bc1Pk+KWS7KpjtQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)