UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ybEBCXrgXVtOXvMoiI05LSbN1nWl9GZptMGLVmkDrho='
WHERE
key_id = 'bdd25dda496390652d143ebb9ec1c38fb30af17410c267a185942f42f8c60ee4'
AND (
token = 'ybEBCXrgXVtOXvMoiI05LSbN1nWl9GZptMGLVmkDrho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)